TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `insert_SOLUONGBAN` AFTER INSERT ON `chitiethoadon` FOR EACH ROW if new.SoLuongBan <= 0  then\nsignal sqlstate \'10500\' set message_text =\'Loi Nhap Sai\';\nend if' 'CREATE DEFINER=`root`@`localhost` TRIGGER `update_THANHTIENBAN` BEFORE UPDATE ON `chitiethoadon` FOR EACH ROW set new.THANHTIENBAN=new.SOLUONGBAN*new.DONGIABAN' 'CREATE DEFINER=`root`@`localhost` TRIGGER `insert_THANHTIENBAN` BEFORE INSERT ON `chitiethoadon`\nFOR EACH ROW SET NEW.THANHTIENBAN = NEW.SOLUONGBAN * NEW.DONGIABAN'
sql_modes=0 0 0
definers='root@localhost' 'root@localhost' 'root@localhost'
client_cs_names='utf8' 'utf8' 'utf8'
connection_cl_names='utf8_general_ci' 'utf8_general_ci' 'utf8_general_ci'
db_cl_names='utf8_general_ci' 'utf8_general_ci' 'utf8_general_ci'
